Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# SHARED_POOL_RESERVED_SIZE

Property | Description
--- | ---
Parameter type | Big integer
Syntax | `SHARED_POOL_RESERVED_SIZE =` `integer` `[K | M | G]`
Default value | 5% of the value of `SHARED_POOL_SIZE`
Modifiable | No
Range of values | Minimum: `5000` Maximum: one half of the value of `SHARED_POOL_SIZE`

`SHARED_POOL_RESERVED_SIZE` specifies (in bytes) the shared pool space that is reserved for large contiguous requests for shared pool memory.

You can use this parameter to avoid performance degradation in the shared pool in situations where pool fragmentation forces Oracle to search for and free chunks of unused pool to satisfy the current request.

See Also: Oracle Database Performance Tuning Guide for more information on setting this parameter "SHARED_POOL_SIZE"